<?php 
    
function list_devisi($start , $limit){
	$header = array(
		'Kompetensi'=>array('style'=>'border-top:2px solid;border-bottom:2px solid;width:40%'),   
		'Tingkat'=>array('style'=>'border-top:2px solid;border-bottom:2px solid;width:10%'),   
		'Indikator'=>array('style'=>'border-top:2px solid;border-bottom:2px solid;width:45%'),   
	);

	$query = "SELECT * FROM kompetensi_indikator a 
	INNER JOIN kompetensi b	ON a.kompetensi_id=b.kompetensi_id 
	ORDER BY a.kompetensi_id, a.tingkat_id";
	$result = my_query($query);
	$ref='';
	$row=array();
	while($ey = my_fetch_array($result)){
		if($ref==$ey['kompetensi_id']){
			$temp='' ;
		}else{
			$temp=$ey['nama_kompetensi'];
			$ref=$ey['kompetensi_id'];
		}	
		$row[] = array(
			'kompetensi'=>  $temp ,   
			'tingkat'=> 	$ey['tingkat_id'] ,   
			'indikator'=>  $ey['indikator'] ,   
		);
		 
	}
	
	$datas = table_cetak_rows($row); 
	return  table_cetak_builder($header , $datas ,  4, false );
} 
?>
<style type="text/css">
<!--

	table.page_header {width: 100%; border: none; background-color: #CDCDCD; border-bottom: solid 1mm #000; padding: 2mm }
	table.page_footer {width: 100%; border: none;  border-top: solid 1mm #000; padding: 2mm}
div.zone
{
	border: solid 2mm #66AACC;
	border-radius: 3mm;
	padding: 1mm;
	background-color: #FFEEEE;
	color: #440000;
}
div.zone_over
{
	width: 30mm;
	height: 35mm;
	overflow: hidden;
}

-->
</style>
<?php 
	$query = "SELECT * FROM kompetensi_indikator a 
	INNER JOIN kompetensi b	ON a.kompetensi_id=b.kompetensi_id 
	ORDER BY a.kompetensi_id, a.tingkat_id";
	
	$result = my_query($query);
	$total = my_num_rows($result);
	$limit = 20;
	$total_page = ceil($total/$limit) -1; 
	for($i = 0; $i<=  $total_page  ;$i++):
	$start =  ( $i * $limit );
	
?>	 
<page style="font-size: 10pt">
	<page_footer>
		<table class="page_footer">
			<tr>
				<td style="width: 33%; text-align: left;">
					 HRIS RSKM 
				</td>
				<td style="width: 34%; text-align: center">
					page [[page_cu]]/[[page_nb]]
				</td>
				<td style="width: 33%; text-align: right">
					M A P &copy; 2010 - <?php echo date('Y'); ?>
				</td>
			</tr>
		</table>
	</page_footer>

	<div style="width: 100%; text-align:center; padding:2px; font-size: 13pt ;">Daftar data unit kompetensi </div>
	<?php echo list_devisi($start , $limit); ?> 
</page>
<?php endfor; ?>